package team.you.change.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import team.you.change.pojo.Class;
import team.you.change.pojo.College;
import team.you.change.pojo.User;

public interface CollegeMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(College record);

    College selectByPrimaryKey(Integer id);
    //查询所有学院专业信息
    List<College> selectAll(@Param("page") Integer page, @Param("limit") Integer limit);

    int updateByPrimaryKey(College record);

    Integer getCount();
    //查询所有学院id
    List<College> selectAllCollId();
    //模糊查询（名称或类型）
    List<College> selectByLike(@Param("value") String value, @Param("type") Integer type, @Param("page") Integer page, @Param("limit") Integer limit);
    //根据学院id 查询其下所有专业id
    List<College> selectAllMajorId(Integer id);
    //查询所有专业
    List<College> selectAllMajor();
}